﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
namespace INTEX.DataBase.Tools
{
    public partial class INTEXDBC
    {
        public void MapWTSAER(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void InsertWTSAER(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "INSERT INTO WTSAER SELECT :WTBMANDANT, :WTBSRFNR, '00', ' ', '                    ', 'N', 'AR', '             ', '      ', 0, 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, '      ', 0, 1, 11, 0, 0, 0, 0, 2, 12, 0, 0, 0, 0, 3, 13, 0, 0, 0, 0, 4, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,"
            + ":WTBAENDBEN, :WTBAENDDAT, :WTBNEUBEN, :WTBNEUDAT, '                                                                  ' FROM DUAL";
            or1.Parameters.Add("WTBMANDANT", OracleType.NVarChar).Value = dwData["WTBMANDANT"].ToString();
            or1.Parameters.Add("WTBSRFNR", OracleType.NVarChar).Value = dwData["WTBSRFNR"].ToString();
            or1.Parameters.Add("WTBAENDBEN", OracleType.NVarChar).Value = dwData["WTBAENDBEN"].ToString();
            or1.Parameters.Add("WTBAENDDAT", OracleType.NVarChar).Value = dwData["WTBAENDDAT"].ToString();
            or1.Parameters.Add("WTBNEUBEN", OracleType.NVarChar).Value = dwData["WTBNEUBEN"].ToString();
            or1.Parameters.Add("WTBNEUDAT", OracleType.NVarChar).Value = dwData["WTBNEUDAT"].ToString();
            Connect2Proxy(or1);
        }
        public void DeleteWTSAER(string client, string art)
        {

            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE WTSAER WHERE   "
            + "  WTBMANDANT=:WTBMANDANT AND WTBSRFNR=:WTBSRFNR";
            or1.Parameters.Add("WTBMANDANT", OracleType.NVarChar).Value = client;
            or1.Parameters.Add("WTBSRFNR", OracleType.NVarChar).Value = art;
            Connect2Proxy(or1);
        }
        public DataSet QueryWTSAER(DataRow dwData,int option=1)
        {
            DataSet setReturn = new DataSet();
            DataSet Result = new DataSet();
            DataTable tbLocal = null;
            OracleCommand or1;
            //select * from WTGEW where WTGART='PV912102            ' AND WTGVAR='12'

            or1 = OracleDB.CreateCommand();
            switch(option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM WTSAER WHERE  ROWNUM<2 ";
                    break;
                case 1:
            or1.CommandText = "SELECT * FROM WTSAER WHERE   "
            + "  WTBMANDANT=:WTBMANDANT AND WTBSRFNR=:WTBSRFNR";
            or1.Parameters.Add("WTBMANDANT", OracleType.NVarChar).Value = dwData["WTBMANDANT"].ToString();
            or1.Parameters.Add("WTBSRFNR", OracleType.NVarChar).Value = dwData["WTBSRFNR"].ToString();
            break;
        }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
            {
                tbLocal = Result.Tables[0];
                tbLocal.TableName = "WTSAER";
            }
            setReturn.Merge(Result);
            return setReturn;
        }
        public void UpdateWTSAER(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE WTSAER SET "
            #region update
 + "WTBFNR100=:WTBFNR100,"
+ "WTBANZFAE100=:WTBANZFAE100,"
+ "WTBAENDZL=:WTBAENDZL,"
+ "WTBAENDBEN=:WTBAENDBEN,"
+ "WTBAENDDAT=:WTBAENDDAT,"
+ "WTBNEUBEN=:WTBNEUBEN,"
+ "WTBNEUDAT=:WTBNEUDAT,"
+ "WTBFILLER=:WTBFILLER,"
+ "WTBMANDANT=:WTBMANDANT,"
+ "WTBSRFNR=:WTBSRFNR,"
+ "WTBPOS=:WTBPOS,"
+ "WTBSTAKZ=:WTBSTAKZ,"
+ "WTBBEZ=:WTBBEZ,"
+ "WTBMUSTER=:WTBMUSTER,"
+ "WTBRAUSGL=:WTBRAUSGL,"
+ "WTBCADKEY1=:WTBCADKEY1,"
+ "WTBCADKEY2=:WTBCADKEY2,"
+ "WTBSRAPP=:WTBSRAPP,"
+ "WTBANZFARB=:WTBANZFARB,"
+ "WTBGARN1=:WTBGARN1,"
+ "WTBFDZ1=:WTBFDZ1,"
+ "WTBGARN2=:WTBGARN2,"
+ "WTBFDZ2=:WTBFDZ2,"
+ "WTBGARN3=:WTBGARN3,"
+ "WTBFDZ3=:WTBFDZ3,"
+ "WTBGARN4=:WTBGARN4,"
+ "WTBFDZ4=:WTBFDZ4,"
+ "WTBGARN5=:WTBGARN5,"
+ "WTBFDZ5=:WTBFDZ5,"
+ "WTBGARN6=:WTBGARN6,"
+ "WTBFDZ6=:WTBFDZ6,"
+ "WTBGARN7=:WTBGARN7,"
+ "WTBFDZ7=:WTBFDZ7,"
+ "WTBGARN8=:WTBGARN8,"
+ "WTBFDZ8=:WTBFDZ8,"
+ "WTBGARN9=:WTBGARN9,"
+ "WTBFDZ9=:WTBFDZ9,"
+ "WTBGARN10=:WTBGARN10,"
+ "WTBFDZ10=:WTBFDZ10,"
+ "WTBGARN11=:WTBGARN11,"
+ "WTBFDZ11=:WTBFDZ11,"
+ "WTBGARN12=:WTBGARN12,"
+ "WTBFDZ12=:WTBFDZ12,"
+ "WTBGARN13=:WTBGARN13,"
+ "WTBFDZ13=:WTBFDZ13,"
+ "WTBGARN14=:WTBGARN14,"
+ "WTBFDZ14=:WTBFDZ14,"
+ "WTBGARN15=:WTBGARN15,"
+ "WTBFDZ15=:WTBFDZ15,"
+ "WTBGARN16=:WTBGARN16,"
+ "WTBFDZ16=:WTBFDZ16,"
+ "WTBGARN17=:WTBGARN17,"
+ "WTBFDZ17=:WTBFDZ17,"
+ "WTBGARN18=:WTBGARN18,"
+ "WTBFDZ18=:WTBFDZ18,"
+ "WTBGARN19=:WTBGARN19,"
+ "WTBFDZ19=:WTBFDZ19,"
+ "WTBGARN20=:WTBGARN20,"
+ "WTBFDZ20=:WTBFDZ20,"
+ "WTBGARN21=:WTBGARN21,"
+ "WTBFDZ21=:WTBFDZ21,"
+ "WTBGARN22=:WTBGARN22,"
+ "WTBFDZ22=:WTBFDZ22,"
+ "WTBGARN23=:WTBGARN23,"
+ "WTBFDZ23=:WTBFDZ23,"
+ "WTBGARN24=:WTBGARN24,"
+ "WTBFDZ24=:WTBFDZ24,"
+ "WTBGARN25=:WTBGARN25,"
+ "WTBFDZ25=:WTBFDZ25,"
+ "WTBGARN26=:WTBGARN26,"
+ "WTBFDZ26=:WTBFDZ26,"
+ "WTBGARN27=:WTBGARN27,"
+ "WTBFDZ27=:WTBFDZ27,"
+ "WTBGARN28=:WTBGARN28,"
+ "WTBFNR42=:WTBFNR42,"
+ "WTBANZFAE42=:WTBANZFAE42,"
+ "WTBFNR43=:WTBFNR43,"
+ "WTBANZFAE43=:WTBANZFAE43,"
+ "WTBFNR44=:WTBFNR44,"
+ "WTBANZFAE44=:WTBANZFAE44,"
+ "WTBFNR45=:WTBFNR45,"
+ "WTBANZFAE45=:WTBANZFAE45,"
+ "WTBFNR46=:WTBFNR46,"
+ "WTBANZFAE46=:WTBANZFAE46,"
+ "WTBFNR47=:WTBFNR47,"
+ "WTBANZFAE47=:WTBANZFAE47,"
+ "WTBFNR48=:WTBFNR48,"
+ "WTBANZFAE48=:WTBANZFAE48,"
+ "WTBFNR49=:WTBFNR49,"
+ "WTBANZFAE49=:WTBANZFAE49,"
+ "WTBFNR50=:WTBFNR50,"
+ "WTBANZFAE50=:WTBANZFAE50,"
+ "WTBFNR51=:WTBFNR51,"
+ "WTBANZFAE51=:WTBANZFAE51,"
+ "WTBFNR52=:WTBFNR52,"
+ "WTBANZFAE52=:WTBANZFAE52,"
+ "WTBFNR53=:WTBFNR53,"
+ "WTBANZFAE53=:WTBANZFAE53,"
+ "WTBFNR54=:WTBFNR54,"
+ "WTBANZFAE54=:WTBANZFAE54,"
+ "WTBFNR55=:WTBFNR55,"
+ "WTBANZFAE55=:WTBANZFAE55,"
+ "WTBFNR56=:WTBFNR56,"
+ "WTBANZFAE56=:WTBANZFAE56,"
+ "WTBFNR57=:WTBFNR57,"
+ "WTBANZFAE57=:WTBANZFAE57,"
+ "WTBFNR58=:WTBFNR58,"
+ "WTBANZFAE58=:WTBANZFAE58,"
+ "WTBFNR59=:WTBFNR59,"
+ "WTBANZFAE59=:WTBANZFAE59,"
+ "WTBFNR60=:WTBFNR60,"
+ "WTBANZFAE60=:WTBANZFAE60,"
+ "WTBFNR23=:WTBFNR23,"
+ "WTBANZFAE23=:WTBANZFAE23,"
+ "WTBFNR24=:WTBFNR24,"
+ "WTBANZFAE24=:WTBANZFAE24,"
+ "WTBFNR25=:WTBFNR25,"
+ "WTBANZFAE25=:WTBANZFAE25,"
+ "WTBFNR26=:WTBFNR26,"
+ "WTBANZFAE26=:WTBANZFAE26,"
+ "WTBFNR27=:WTBFNR27,"
+ "WTBANZFAE27=:WTBANZFAE27,"
+ "WTBFNR28=:WTBFNR28,"
+ "WTBANZFAE28=:WTBANZFAE28,"
+ "WTBFNR29=:WTBFNR29,"
+ "WTBANZFAE29=:WTBANZFAE29,"
+ "WTBFNR30=:WTBFNR30,"
+ "WTBANZFAE30=:WTBANZFAE30,"
+ "WTBFNR31=:WTBFNR31,"
+ "WTBANZFAE31=:WTBANZFAE31,"
+ "WTBFNR32=:WTBFNR32,"
+ "WTBANZFAE32=:WTBANZFAE32,"
+ "WTBFNR33=:WTBFNR33,"
+ "WTBANZFAE33=:WTBANZFAE33,"
+ "WTBFNR34=:WTBFNR34,"
+ "WTBANZFAE34=:WTBANZFAE34,"
+ "WTBFNR35=:WTBFNR35,"
+ "WTBANZFAE35=:WTBANZFAE35,"
+ "WTBFNR36=:WTBFNR36,"
+ "WTBANZFAE36=:WTBANZFAE36,"
+ "WTBFNR37=:WTBFNR37,"
+ "WTBANZFAE37=:WTBANZFAE37,"
+ "WTBFNR38=:WTBFNR38,"
+ "WTBANZFAE38=:WTBANZFAE38,"
+ "WTBFNR39=:WTBFNR39,"
+ "WTBANZFAE39=:WTBANZFAE39,"
+ "WTBFNR40=:WTBFNR40,"
+ "WTBANZFAE40=:WTBANZFAE40,"
+ "WTBFNR41=:WTBFNR41,"
+ "WTBANZFAE41=:WTBANZFAE41,"
+ "WTBANZFAE80=:WTBANZFAE80,"
+ "WTBFNR81=:WTBFNR81,"
+ "WTBANZFAE81=:WTBANZFAE81,"
+ "WTBFNR82=:WTBFNR82,"
+ "WTBANZFAE82=:WTBANZFAE82,"
+ "WTBFNR83=:WTBFNR83,"
+ "WTBANZFAE83=:WTBANZFAE83,"
+ "WTBFNR84=:WTBFNR84,"
+ "WTBANZFAE84=:WTBANZFAE84,"
+ "WTBFNR85=:WTBFNR85,"
+ "WTBANZFAE85=:WTBANZFAE85,"
+ "WTBFNR86=:WTBFNR86,"
+ "WTBANZFAE86=:WTBANZFAE86,"
+ "WTBFNR87=:WTBFNR87,"
+ "WTBANZFAE87=:WTBANZFAE87,"
+ "WTBFNR88=:WTBFNR88,"
+ "WTBANZFAE88=:WTBANZFAE88,"
+ "WTBFNR89=:WTBFNR89,"
+ "WTBANZFAE89=:WTBANZFAE89,"
+ "WTBFNR90=:WTBFNR90,"
+ "WTBANZFAE90=:WTBANZFAE90,"
+ "WTBFNR91=:WTBFNR91,"
+ "WTBANZFAE91=:WTBANZFAE91,"
+ "WTBFNR92=:WTBFNR92,"
+ "WTBANZFAE92=:WTBANZFAE92,"
+ "WTBFNR93=:WTBFNR93,"
+ "WTBANZFAE93=:WTBANZFAE93,"
+ "WTBFNR94=:WTBFNR94,"
+ "WTBANZFAE94=:WTBANZFAE94,"
+ "WTBFNR95=:WTBFNR95,"
+ "WTBANZFAE95=:WTBANZFAE95,"
+ "WTBFNR96=:WTBFNR96,"
+ "WTBANZFAE96=:WTBANZFAE96,"
+ "WTBFNR97=:WTBFNR97,"
+ "WTBANZFAE97=:WTBANZFAE97,"
+ "WTBFNR98=:WTBFNR98,"
+ "WTBANZFAE98=:WTBANZFAE98,"
+ "WTBFNR99=:WTBFNR99,"
+ "WTBANZFAE99=:WTBANZFAE99,"
+ "WTBFNR4=:WTBFNR4,"
+ "WTBANZFAE4=:WTBANZFAE4,"
+ "WTBFNR5=:WTBFNR5,"
+ "WTBANZFAE5=:WTBANZFAE5,"
+ "WTBFNR6=:WTBFNR6,"
+ "WTBANZFAE6=:WTBANZFAE6,"
+ "WTBFNR7=:WTBFNR7,"
+ "WTBANZFAE7=:WTBANZFAE7,"
+ "WTBFNR8=:WTBFNR8,"
+ "WTBANZFAE8=:WTBANZFAE8,"
+ "WTBFNR9=:WTBFNR9,"
+ "WTBANZFAE9=:WTBANZFAE9,"
+ "WTBFNR10=:WTBFNR10,"
+ "WTBANZFAE10=:WTBANZFAE10,"
+ "WTBFNR11=:WTBFNR11,"
+ "WTBANZFAE11=:WTBANZFAE11,"
+ "WTBFNR12=:WTBFNR12,"
+ "WTBANZFAE12=:WTBANZFAE12,"
+ "WTBFNR13=:WTBFNR13,"
+ "WTBANZFAE13=:WTBANZFAE13,"
+ "WTBFNR14=:WTBFNR14,"
+ "WTBANZFAE14=:WTBANZFAE14,"
+ "WTBFNR15=:WTBFNR15,"
+ "WTBANZFAE15=:WTBANZFAE15,"
+ "WTBFNR16=:WTBFNR16,"
+ "WTBANZFAE16=:WTBANZFAE16,"
+ "WTBFNR17=:WTBFNR17,"
+ "WTBANZFAE17=:WTBANZFAE17,"
+ "WTBFNR18=:WTBFNR18,"
+ "WTBANZFAE18=:WTBANZFAE18,"
+ "WTBFNR19=:WTBFNR19,"
+ "WTBANZFAE19=:WTBANZFAE19,"
+ "WTBFNR20=:WTBFNR20,"
+ "WTBANZFAE20=:WTBANZFAE20,"
+ "WTBFNR21=:WTBFNR21,"
+ "WTBANZFAE21=:WTBANZFAE21,"
+ "WTBFNR22=:WTBFNR22,"
+ "WTBANZFAE22=:WTBANZFAE22,"
+ "WTBFDZ28=:WTBFDZ28,"
+ "WTBGARN29=:WTBGARN29,"
+ "WTBFDZ29=:WTBFDZ29,"
+ "WTBGARN30=:WTBGARN30,"
+ "WTBFDZ30=:WTBFDZ30,"
+ "WTBGARN31=:WTBGARN31,"
+ "WTBFDZ31=:WTBFDZ31,"
+ "WTBGARN32=:WTBGARN32,"
+ "WTBFDZ32=:WTBFDZ32,"
+ "WTBGARN33=:WTBGARN33,"
+ "WTBFDZ33=:WTBFDZ33,"
+ "WTBGARN34=:WTBGARN34,"
+ "WTBFDZ34=:WTBFDZ34,"
+ "WTBGARN35=:WTBGARN35,"
+ "WTBFDZ35=:WTBFDZ35,"
+ "WTBGARN36=:WTBGARN36,"
+ "WTBFDZ36=:WTBFDZ36,"
+ "WTBGARN37=:WTBGARN37,"
+ "WTBFDZ37=:WTBFDZ37,"
+ "WTBGARN38=:WTBGARN38,"
+ "WTBFDZ38=:WTBFDZ38,"
+ "WTBGARN39=:WTBGARN39,"
+ "WTBFDZ39=:WTBFDZ39,"
+ "WTBGARN40=:WTBGARN40,"
+ "WTBFDZ40=:WTBFDZ40,"
+ "WTBGARN41=:WTBGARN41,"
+ "WTBFDZ41=:WTBFDZ41,"
+ "WTBGARN42=:WTBGARN42,"
+ "WTBFDZ42=:WTBFDZ42,"
+ "WTBGARN43=:WTBGARN43,"
+ "WTBFDZ43=:WTBFDZ43,"
+ "WTBGARN44=:WTBGARN44,"
+ "WTBFDZ44=:WTBFDZ44,"
+ "WTBGARN45=:WTBGARN45,"
+ "WTBFDZ45=:WTBFDZ45,"
+ "WTBGARN46=:WTBGARN46,"
+ "WTBFDZ46=:WTBFDZ46,"
+ "WTBGARN47=:WTBGARN47,"
+ "WTBFDZ47=:WTBFDZ47,"
+ "WTBGARN48=:WTBGARN48,"
+ "WTBFDZ48=:WTBFDZ48,"
+ "WTBGARN49=:WTBGARN49,"
+ "WTBFDZ49=:WTBFDZ49,"
+ "WTBGARN50=:WTBGARN50,"
+ "WTBFDZ50=:WTBFDZ50,"
+ "WTBGARN51=:WTBGARN51,"
+ "WTBFDZ51=:WTBFDZ51,"
+ "WTBGARN52=:WTBGARN52,"
+ "WTBFDZ52=:WTBFDZ52,"
+ "WTBGARN53=:WTBGARN53,"
+ "WTBFDZ53=:WTBFDZ53,"
+ "WTBGARN54=:WTBGARN54,"
+ "WTBFDZ54=:WTBFDZ54,"
+ "WTBGARN55=:WTBGARN55,"
+ "WTBFDZ55=:WTBFDZ55,"
+ "WTBGARN56=:WTBGARN56,"
+ "WTBFDZ56=:WTBFDZ56,"
+ "WTBGARN57=:WTBGARN57,"
+ "WTBFDZ57=:WTBFDZ57,"
+ "WTBGARN58=:WTBGARN58,"
+ "WTBFDZ58=:WTBFDZ58,"
+ "WTBGARN59=:WTBGARN59,"
+ "WTBFDZ59=:WTBFDZ59,"
+ "WTBGARN60=:WTBGARN60,"
+ "WTBFDZ60=:WTBFDZ60,"
+ "WTBGARN61=:WTBGARN61,"
+ "WTBFDZ61=:WTBFDZ61,"
+ "WTBGARN62=:WTBGARN62,"
+ "WTBFDZ62=:WTBFDZ62,"
+ "WTBGARN63=:WTBGARN63,"
+ "WTBFDZ63=:WTBFDZ63,"
+ "WTBGARN64=:WTBGARN64,"
+ "WTBFDZ64=:WTBFDZ64,"
+ "WTBGARN65=:WTBGARN65,"
+ "WTBFDZ65=:WTBFDZ65,"
+ "WTBGARN66=:WTBGARN66,"
+ "WTBFDZ66=:WTBFDZ66,"
+ "WTBGARN67=:WTBGARN67,"
+ "WTBFDZ67=:WTBFDZ67,"
+ "WTBGARN68=:WTBGARN68,"
+ "WTBFDZ68=:WTBFDZ68,"
+ "WTBGARN69=:WTBGARN69,"
+ "WTBFDZ69=:WTBFDZ69,"
+ "WTBGARN70=:WTBGARN70,"
+ "WTBFDZ70=:WTBFDZ70,"
+ "WTBGARN71=:WTBGARN71,"
+ "WTBFDZ71=:WTBFDZ71,"
+ "WTBGARN72=:WTBGARN72,"
+ "WTBFDZ72=:WTBFDZ72,"
+ "WTBGARN73=:WTBGARN73,"
+ "WTBFDZ73=:WTBFDZ73,"
+ "WTBGARN74=:WTBGARN74,"
+ "WTBFDZ74=:WTBFDZ74,"
+ "WTBGARN75=:WTBGARN75,"
+ "WTBFDZ75=:WTBFDZ75,"
+ "WTBGARN76=:WTBGARN76,"
+ "WTBFDZ76=:WTBFDZ76,"
+ "WTBGARN77=:WTBGARN77,"
+ "WTBFDZ77=:WTBFDZ77,"
+ "WTBGARN78=:WTBGARN78,"
+ "WTBFDZ78=:WTBFDZ78,"
+ "WTBGARN79=:WTBGARN79,"
+ "WTBFDZ79=:WTBFDZ79,"
+ "WTBGARN80=:WTBGARN80,"
+ "WTBFDZ80=:WTBFDZ80,"
+ "WTBFNR1=:WTBFNR1,"
+ "WTBANZFAE1=:WTBANZFAE1,"
+ "WTBFNR2=:WTBFNR2,"
+ "WTBANZFAE2=:WTBANZFAE2,"
+ "WTBFNR3=:WTBFNR3,"
+ "WTBANZFAE3=:WTBANZFAE3,"
+ "WTBFNR61=:WTBFNR61,"
+ "WTBANZFAE61=:WTBANZFAE61,"
+ "WTBFNR62=:WTBFNR62,"
+ "WTBANZFAE62=:WTBANZFAE62,"
+ "WTBFNR63=:WTBFNR63,"
+ "WTBANZFAE63=:WTBANZFAE63,"
+ "WTBFNR64=:WTBFNR64,"
+ "WTBANZFAE64=:WTBANZFAE64,"
+ "WTBFNR65=:WTBFNR65,"
+ "WTBANZFAE65=:WTBANZFAE65,"
+ "WTBFNR66=:WTBFNR66,"
+ "WTBANZFAE66=:WTBANZFAE66,"
+ "WTBFNR67=:WTBFNR67,"
+ "WTBANZFAE67=:WTBANZFAE67,"
+ "WTBFNR68=:WTBFNR68,"
+ "WTBANZFAE68=:WTBANZFAE68,"
+ "WTBFNR69=:WTBFNR69,"
+ "WTBANZFAE69=:WTBANZFAE69,"
+ "WTBFNR70=:WTBFNR70,"
+ "WTBANZFAE70=:WTBANZFAE70,"
+ "WTBFNR71=:WTBFNR71,"
+ "WTBANZFAE71=:WTBANZFAE71,"
+ "WTBFNR72=:WTBFNR72,"
+ "WTBANZFAE72=:WTBANZFAE72,"
+ "WTBFNR73=:WTBFNR73,"
+ "WTBANZFAE73=:WTBANZFAE73,"
+ "WTBFNR74=:WTBFNR74,"
+ "WTBANZFAE74=:WTBANZFAE74,"
+ "WTBFNR75=:WTBFNR75,"
+ "WTBANZFAE75=:WTBANZFAE75,"
+ "WTBFNR76=:WTBFNR76,"
+ "WTBANZFAE76=:WTBANZFAE76,"
+ "WTBFNR77=:WTBFNR77,"
+ "WTBANZFAE77=:WTBANZFAE77,"
+ "WTBFNR78=:WTBFNR78,"
+ "WTBANZFAE78=:WTBANZFAE78,"
+ "WTBFNR79=:WTBFNR79,"
+ "WTBANZFAE79=:WTBANZFAE79,"
+ "WTBFNR80=:WTBFNR80 "
            #endregion
 + " WHERE  "
            + "  WTBMANDANT=:WTBMANDANT AND WTBSRFNR=:WTBSRFNR";
            #region====cond====
            or1.Parameters.Add("WTBFNR100", OracleType.NVarChar).Value = dwData["WTBFNR100"].ToString();
            or1.Parameters.Add("WTBANZFAE100", OracleType.NVarChar).Value = dwData["WTBANZFAE100"].ToString();
            or1.Parameters.Add("WTBAENDZL", OracleType.NVarChar).Value = dwData["WTBAENDZL"].ToString();
            or1.Parameters.Add("WTBAENDBEN", OracleType.NVarChar).Value = dwData["WTBAENDBEN"].ToString();
            or1.Parameters.Add("WTBAENDDAT", OracleType.NVarChar).Value = dwData["WTBAENDDAT"].ToString();
            or1.Parameters.Add("WTBNEUBEN", OracleType.NVarChar).Value = dwData["WTBNEUBEN"].ToString();
            or1.Parameters.Add("WTBNEUDAT", OracleType.NVarChar).Value = dwData["WTBNEUDAT"].ToString();
            or1.Parameters.Add("WTBFILLER", OracleType.NVarChar).Value = dwData["WTBFILLER"].ToString();
            or1.Parameters.Add("WTBMANDANT", OracleType.NVarChar).Value = dwData["WTBMANDANT"].ToString();
            or1.Parameters.Add("WTBSRFNR", OracleType.NVarChar).Value = dwData["WTBSRFNR"].ToString();
            or1.Parameters.Add("WTBPOS", OracleType.NVarChar).Value = dwData["WTBPOS"].ToString();
            or1.Parameters.Add("WTBSTAKZ", OracleType.NVarChar).Value = dwData["WTBSTAKZ"].ToString();
            or1.Parameters.Add("WTBBEZ", OracleType.NVarChar).Value = dwData["WTBBEZ"].ToString();
            or1.Parameters.Add("WTBMUSTER", OracleType.NVarChar).Value = dwData["WTBMUSTER"].ToString();
            or1.Parameters.Add("WTBRAUSGL", OracleType.NVarChar).Value = dwData["WTBRAUSGL"].ToString();
            or1.Parameters.Add("WTBCADKEY1", OracleType.NVarChar).Value = dwData["WTBCADKEY1"].ToString();
            or1.Parameters.Add("WTBCADKEY2", OracleType.NVarChar).Value = dwData["WTBCADKEY2"].ToString();
            or1.Parameters.Add("WTBSRAPP", OracleType.NVarChar).Value = dwData["WTBSRAPP"].ToString();
            or1.Parameters.Add("WTBANZFARB", OracleType.NVarChar).Value = dwData["WTBANZFARB"].ToString();
            or1.Parameters.Add("WTBGARN1", OracleType.NVarChar).Value = dwData["WTBGARN1"].ToString();
            or1.Parameters.Add("WTBFDZ1", OracleType.NVarChar).Value = dwData["WTBFDZ1"].ToString();
            or1.Parameters.Add("WTBGARN2", OracleType.NVarChar).Value = dwData["WTBGARN2"].ToString();
            or1.Parameters.Add("WTBFDZ2", OracleType.NVarChar).Value = dwData["WTBFDZ2"].ToString();
            or1.Parameters.Add("WTBGARN3", OracleType.NVarChar).Value = dwData["WTBGARN3"].ToString();
            or1.Parameters.Add("WTBFDZ3", OracleType.NVarChar).Value = dwData["WTBFDZ3"].ToString();
            or1.Parameters.Add("WTBGARN4", OracleType.NVarChar).Value = dwData["WTBGARN4"].ToString();
            or1.Parameters.Add("WTBFDZ4", OracleType.NVarChar).Value = dwData["WTBFDZ4"].ToString();
            or1.Parameters.Add("WTBGARN5", OracleType.NVarChar).Value = dwData["WTBGARN5"].ToString();
            or1.Parameters.Add("WTBFDZ5", OracleType.NVarChar).Value = dwData["WTBFDZ5"].ToString();
            or1.Parameters.Add("WTBGARN6", OracleType.NVarChar).Value = dwData["WTBGARN6"].ToString();
            or1.Parameters.Add("WTBFDZ6", OracleType.NVarChar).Value = dwData["WTBFDZ6"].ToString();
            or1.Parameters.Add("WTBGARN7", OracleType.NVarChar).Value = dwData["WTBGARN7"].ToString();
            or1.Parameters.Add("WTBFDZ7", OracleType.NVarChar).Value = dwData["WTBFDZ7"].ToString();
            or1.Parameters.Add("WTBGARN8", OracleType.NVarChar).Value = dwData["WTBGARN8"].ToString();
            or1.Parameters.Add("WTBFDZ8", OracleType.NVarChar).Value = dwData["WTBFDZ8"].ToString();
            or1.Parameters.Add("WTBGARN9", OracleType.NVarChar).Value = dwData["WTBGARN9"].ToString();
            or1.Parameters.Add("WTBFDZ9", OracleType.NVarChar).Value = dwData["WTBFDZ9"].ToString();
            or1.Parameters.Add("WTBGARN10", OracleType.NVarChar).Value = dwData["WTBGARN10"].ToString();
            or1.Parameters.Add("WTBFDZ10", OracleType.NVarChar).Value = dwData["WTBFDZ10"].ToString();
            or1.Parameters.Add("WTBGARN11", OracleType.NVarChar).Value = dwData["WTBGARN11"].ToString();
            or1.Parameters.Add("WTBFDZ11", OracleType.NVarChar).Value = dwData["WTBFDZ11"].ToString();
            or1.Parameters.Add("WTBGARN12", OracleType.NVarChar).Value = dwData["WTBGARN12"].ToString();
            or1.Parameters.Add("WTBFDZ12", OracleType.NVarChar).Value = dwData["WTBFDZ12"].ToString();
            or1.Parameters.Add("WTBGARN13", OracleType.NVarChar).Value = dwData["WTBGARN13"].ToString();
            or1.Parameters.Add("WTBFDZ13", OracleType.NVarChar).Value = dwData["WTBFDZ13"].ToString();
            or1.Parameters.Add("WTBGARN14", OracleType.NVarChar).Value = dwData["WTBGARN14"].ToString();
            or1.Parameters.Add("WTBFDZ14", OracleType.NVarChar).Value = dwData["WTBFDZ14"].ToString();
            or1.Parameters.Add("WTBGARN15", OracleType.NVarChar).Value = dwData["WTBGARN15"].ToString();
            or1.Parameters.Add("WTBFDZ15", OracleType.NVarChar).Value = dwData["WTBFDZ15"].ToString();
            or1.Parameters.Add("WTBGARN16", OracleType.NVarChar).Value = dwData["WTBGARN16"].ToString();
            or1.Parameters.Add("WTBFDZ16", OracleType.NVarChar).Value = dwData["WTBFDZ16"].ToString();
            or1.Parameters.Add("WTBGARN17", OracleType.NVarChar).Value = dwData["WTBGARN17"].ToString();
            or1.Parameters.Add("WTBFDZ17", OracleType.NVarChar).Value = dwData["WTBFDZ17"].ToString();
            or1.Parameters.Add("WTBGARN18", OracleType.NVarChar).Value = dwData["WTBGARN18"].ToString();
            or1.Parameters.Add("WTBFDZ18", OracleType.NVarChar).Value = dwData["WTBFDZ18"].ToString();
            or1.Parameters.Add("WTBGARN19", OracleType.NVarChar).Value = dwData["WTBGARN19"].ToString();
            or1.Parameters.Add("WTBFDZ19", OracleType.NVarChar).Value = dwData["WTBFDZ19"].ToString();
            or1.Parameters.Add("WTBGARN20", OracleType.NVarChar).Value = dwData["WTBGARN20"].ToString();
            or1.Parameters.Add("WTBFDZ20", OracleType.NVarChar).Value = dwData["WTBFDZ20"].ToString();
            or1.Parameters.Add("WTBGARN21", OracleType.NVarChar).Value = dwData["WTBGARN21"].ToString();
            or1.Parameters.Add("WTBFDZ21", OracleType.NVarChar).Value = dwData["WTBFDZ21"].ToString();
            or1.Parameters.Add("WTBGARN22", OracleType.NVarChar).Value = dwData["WTBGARN22"].ToString();
            or1.Parameters.Add("WTBFDZ22", OracleType.NVarChar).Value = dwData["WTBFDZ22"].ToString();
            or1.Parameters.Add("WTBGARN23", OracleType.NVarChar).Value = dwData["WTBGARN23"].ToString();
            or1.Parameters.Add("WTBFDZ23", OracleType.NVarChar).Value = dwData["WTBFDZ23"].ToString();
            or1.Parameters.Add("WTBGARN24", OracleType.NVarChar).Value = dwData["WTBGARN24"].ToString();
            or1.Parameters.Add("WTBFDZ24", OracleType.NVarChar).Value = dwData["WTBFDZ24"].ToString();
            or1.Parameters.Add("WTBGARN25", OracleType.NVarChar).Value = dwData["WTBGARN25"].ToString();
            or1.Parameters.Add("WTBFDZ25", OracleType.NVarChar).Value = dwData["WTBFDZ25"].ToString();
            or1.Parameters.Add("WTBGARN26", OracleType.NVarChar).Value = dwData["WTBGARN26"].ToString();
            or1.Parameters.Add("WTBFDZ26", OracleType.NVarChar).Value = dwData["WTBFDZ26"].ToString();
            or1.Parameters.Add("WTBGARN27", OracleType.NVarChar).Value = dwData["WTBGARN27"].ToString();
            or1.Parameters.Add("WTBFDZ27", OracleType.NVarChar).Value = dwData["WTBFDZ27"].ToString();
            or1.Parameters.Add("WTBGARN28", OracleType.NVarChar).Value = dwData["WTBGARN28"].ToString();
            or1.Parameters.Add("WTBFNR42", OracleType.NVarChar).Value = dwData["WTBFNR42"].ToString();
            or1.Parameters.Add("WTBANZFAE42", OracleType.NVarChar).Value = dwData["WTBANZFAE42"].ToString();
            or1.Parameters.Add("WTBFNR43", OracleType.NVarChar).Value = dwData["WTBFNR43"].ToString();
            or1.Parameters.Add("WTBANZFAE43", OracleType.NVarChar).Value = dwData["WTBANZFAE43"].ToString();
            or1.Parameters.Add("WTBFNR44", OracleType.NVarChar).Value = dwData["WTBFNR44"].ToString();
            or1.Parameters.Add("WTBANZFAE44", OracleType.NVarChar).Value = dwData["WTBANZFAE44"].ToString();
            or1.Parameters.Add("WTBFNR45", OracleType.NVarChar).Value = dwData["WTBFNR45"].ToString();
            or1.Parameters.Add("WTBANZFAE45", OracleType.NVarChar).Value = dwData["WTBANZFAE45"].ToString();
            or1.Parameters.Add("WTBFNR46", OracleType.NVarChar).Value = dwData["WTBFNR46"].ToString();
            or1.Parameters.Add("WTBANZFAE46", OracleType.NVarChar).Value = dwData["WTBANZFAE46"].ToString();
            or1.Parameters.Add("WTBFNR47", OracleType.NVarChar).Value = dwData["WTBFNR47"].ToString();
            or1.Parameters.Add("WTBANZFAE47", OracleType.NVarChar).Value = dwData["WTBANZFAE47"].ToString();
            or1.Parameters.Add("WTBFNR48", OracleType.NVarChar).Value = dwData["WTBFNR48"].ToString();
            or1.Parameters.Add("WTBANZFAE48", OracleType.NVarChar).Value = dwData["WTBANZFAE48"].ToString();
            or1.Parameters.Add("WTBFNR49", OracleType.NVarChar).Value = dwData["WTBFNR49"].ToString();
            or1.Parameters.Add("WTBANZFAE49", OracleType.NVarChar).Value = dwData["WTBANZFAE49"].ToString();
            or1.Parameters.Add("WTBFNR50", OracleType.NVarChar).Value = dwData["WTBFNR50"].ToString();
            or1.Parameters.Add("WTBANZFAE50", OracleType.NVarChar).Value = dwData["WTBANZFAE50"].ToString();
            or1.Parameters.Add("WTBFNR51", OracleType.NVarChar).Value = dwData["WTBFNR51"].ToString();
            or1.Parameters.Add("WTBANZFAE51", OracleType.NVarChar).Value = dwData["WTBANZFAE51"].ToString();
            or1.Parameters.Add("WTBFNR52", OracleType.NVarChar).Value = dwData["WTBFNR52"].ToString();
            or1.Parameters.Add("WTBANZFAE52", OracleType.NVarChar).Value = dwData["WTBANZFAE52"].ToString();
            or1.Parameters.Add("WTBFNR53", OracleType.NVarChar).Value = dwData["WTBFNR53"].ToString();
            or1.Parameters.Add("WTBANZFAE53", OracleType.NVarChar).Value = dwData["WTBANZFAE53"].ToString();
            or1.Parameters.Add("WTBFNR54", OracleType.NVarChar).Value = dwData["WTBFNR54"].ToString();
            or1.Parameters.Add("WTBANZFAE54", OracleType.NVarChar).Value = dwData["WTBANZFAE54"].ToString();
            or1.Parameters.Add("WTBFNR55", OracleType.NVarChar).Value = dwData["WTBFNR55"].ToString();
            or1.Parameters.Add("WTBANZFAE55", OracleType.NVarChar).Value = dwData["WTBANZFAE55"].ToString();
            or1.Parameters.Add("WTBFNR56", OracleType.NVarChar).Value = dwData["WTBFNR56"].ToString();
            or1.Parameters.Add("WTBANZFAE56", OracleType.NVarChar).Value = dwData["WTBANZFAE56"].ToString();
            or1.Parameters.Add("WTBFNR57", OracleType.NVarChar).Value = dwData["WTBFNR57"].ToString();
            or1.Parameters.Add("WTBANZFAE57", OracleType.NVarChar).Value = dwData["WTBANZFAE57"].ToString();
            or1.Parameters.Add("WTBFNR58", OracleType.NVarChar).Value = dwData["WTBFNR58"].ToString();
            or1.Parameters.Add("WTBANZFAE58", OracleType.NVarChar).Value = dwData["WTBANZFAE58"].ToString();
            or1.Parameters.Add("WTBFNR59", OracleType.NVarChar).Value = dwData["WTBFNR59"].ToString();
            or1.Parameters.Add("WTBANZFAE59", OracleType.NVarChar).Value = dwData["WTBANZFAE59"].ToString();
            or1.Parameters.Add("WTBFNR60", OracleType.NVarChar).Value = dwData["WTBFNR60"].ToString();
            or1.Parameters.Add("WTBANZFAE60", OracleType.NVarChar).Value = dwData["WTBANZFAE60"].ToString();
            or1.Parameters.Add("WTBFNR23", OracleType.NVarChar).Value = dwData["WTBFNR23"].ToString();
            or1.Parameters.Add("WTBANZFAE23", OracleType.NVarChar).Value = dwData["WTBANZFAE23"].ToString();
            or1.Parameters.Add("WTBFNR24", OracleType.NVarChar).Value = dwData["WTBFNR24"].ToString();
            or1.Parameters.Add("WTBANZFAE24", OracleType.NVarChar).Value = dwData["WTBANZFAE24"].ToString();
            or1.Parameters.Add("WTBFNR25", OracleType.NVarChar).Value = dwData["WTBFNR25"].ToString();
            or1.Parameters.Add("WTBANZFAE25", OracleType.NVarChar).Value = dwData["WTBANZFAE25"].ToString();
            or1.Parameters.Add("WTBFNR26", OracleType.NVarChar).Value = dwData["WTBFNR26"].ToString();
            or1.Parameters.Add("WTBANZFAE26", OracleType.NVarChar).Value = dwData["WTBANZFAE26"].ToString();
            or1.Parameters.Add("WTBFNR27", OracleType.NVarChar).Value = dwData["WTBFNR27"].ToString();
            or1.Parameters.Add("WTBANZFAE27", OracleType.NVarChar).Value = dwData["WTBANZFAE27"].ToString();
            or1.Parameters.Add("WTBFNR28", OracleType.NVarChar).Value = dwData["WTBFNR28"].ToString();
            or1.Parameters.Add("WTBANZFAE28", OracleType.NVarChar).Value = dwData["WTBANZFAE28"].ToString();
            or1.Parameters.Add("WTBFNR29", OracleType.NVarChar).Value = dwData["WTBFNR29"].ToString();
            or1.Parameters.Add("WTBANZFAE29", OracleType.NVarChar).Value = dwData["WTBANZFAE29"].ToString();
            or1.Parameters.Add("WTBFNR30", OracleType.NVarChar).Value = dwData["WTBFNR30"].ToString();
            or1.Parameters.Add("WTBANZFAE30", OracleType.NVarChar).Value = dwData["WTBANZFAE30"].ToString();
            or1.Parameters.Add("WTBFNR31", OracleType.NVarChar).Value = dwData["WTBFNR31"].ToString();
            or1.Parameters.Add("WTBANZFAE31", OracleType.NVarChar).Value = dwData["WTBANZFAE31"].ToString();
            or1.Parameters.Add("WTBFNR32", OracleType.NVarChar).Value = dwData["WTBFNR32"].ToString();
            or1.Parameters.Add("WTBANZFAE32", OracleType.NVarChar).Value = dwData["WTBANZFAE32"].ToString();
            or1.Parameters.Add("WTBFNR33", OracleType.NVarChar).Value = dwData["WTBFNR33"].ToString();
            or1.Parameters.Add("WTBANZFAE33", OracleType.NVarChar).Value = dwData["WTBANZFAE33"].ToString();
            or1.Parameters.Add("WTBFNR34", OracleType.NVarChar).Value = dwData["WTBFNR34"].ToString();
            or1.Parameters.Add("WTBANZFAE34", OracleType.NVarChar).Value = dwData["WTBANZFAE34"].ToString();
            or1.Parameters.Add("WTBFNR35", OracleType.NVarChar).Value = dwData["WTBFNR35"].ToString();
            or1.Parameters.Add("WTBANZFAE35", OracleType.NVarChar).Value = dwData["WTBANZFAE35"].ToString();
            or1.Parameters.Add("WTBFNR36", OracleType.NVarChar).Value = dwData["WTBFNR36"].ToString();
            or1.Parameters.Add("WTBANZFAE36", OracleType.NVarChar).Value = dwData["WTBANZFAE36"].ToString();
            or1.Parameters.Add("WTBFNR37", OracleType.NVarChar).Value = dwData["WTBFNR37"].ToString();
            or1.Parameters.Add("WTBANZFAE37", OracleType.NVarChar).Value = dwData["WTBANZFAE37"].ToString();
            or1.Parameters.Add("WTBFNR38", OracleType.NVarChar).Value = dwData["WTBFNR38"].ToString();
            or1.Parameters.Add("WTBANZFAE38", OracleType.NVarChar).Value = dwData["WTBANZFAE38"].ToString();
            or1.Parameters.Add("WTBFNR39", OracleType.NVarChar).Value = dwData["WTBFNR39"].ToString();
            or1.Parameters.Add("WTBANZFAE39", OracleType.NVarChar).Value = dwData["WTBANZFAE39"].ToString();
            or1.Parameters.Add("WTBFNR40", OracleType.NVarChar).Value = dwData["WTBFNR40"].ToString();
            or1.Parameters.Add("WTBANZFAE40", OracleType.NVarChar).Value = dwData["WTBANZFAE40"].ToString();
            or1.Parameters.Add("WTBFNR41", OracleType.NVarChar).Value = dwData["WTBFNR41"].ToString();
            or1.Parameters.Add("WTBANZFAE41", OracleType.NVarChar).Value = dwData["WTBANZFAE41"].ToString();
            or1.Parameters.Add("WTBANZFAE80", OracleType.NVarChar).Value = dwData["WTBANZFAE80"].ToString();
            or1.Parameters.Add("WTBFNR81", OracleType.NVarChar).Value = dwData["WTBFNR81"].ToString();
            or1.Parameters.Add("WTBANZFAE81", OracleType.NVarChar).Value = dwData["WTBANZFAE81"].ToString();
            or1.Parameters.Add("WTBFNR82", OracleType.NVarChar).Value = dwData["WTBFNR82"].ToString();
            or1.Parameters.Add("WTBANZFAE82", OracleType.NVarChar).Value = dwData["WTBANZFAE82"].ToString();
            or1.Parameters.Add("WTBFNR83", OracleType.NVarChar).Value = dwData["WTBFNR83"].ToString();
            or1.Parameters.Add("WTBANZFAE83", OracleType.NVarChar).Value = dwData["WTBANZFAE83"].ToString();
            or1.Parameters.Add("WTBFNR84", OracleType.NVarChar).Value = dwData["WTBFNR84"].ToString();
            or1.Parameters.Add("WTBANZFAE84", OracleType.NVarChar).Value = dwData["WTBANZFAE84"].ToString();
            or1.Parameters.Add("WTBFNR85", OracleType.NVarChar).Value = dwData["WTBFNR85"].ToString();
            or1.Parameters.Add("WTBANZFAE85", OracleType.NVarChar).Value = dwData["WTBANZFAE85"].ToString();
            or1.Parameters.Add("WTBFNR86", OracleType.NVarChar).Value = dwData["WTBFNR86"].ToString();
            or1.Parameters.Add("WTBANZFAE86", OracleType.NVarChar).Value = dwData["WTBANZFAE86"].ToString();
            or1.Parameters.Add("WTBFNR87", OracleType.NVarChar).Value = dwData["WTBFNR87"].ToString();
            or1.Parameters.Add("WTBANZFAE87", OracleType.NVarChar).Value = dwData["WTBANZFAE87"].ToString();
            or1.Parameters.Add("WTBFNR88", OracleType.NVarChar).Value = dwData["WTBFNR88"].ToString();
            or1.Parameters.Add("WTBANZFAE88", OracleType.NVarChar).Value = dwData["WTBANZFAE88"].ToString();
            or1.Parameters.Add("WTBFNR89", OracleType.NVarChar).Value = dwData["WTBFNR89"].ToString();
            or1.Parameters.Add("WTBANZFAE89", OracleType.NVarChar).Value = dwData["WTBANZFAE89"].ToString();
            or1.Parameters.Add("WTBFNR90", OracleType.NVarChar).Value = dwData["WTBFNR90"].ToString();
            or1.Parameters.Add("WTBANZFAE90", OracleType.NVarChar).Value = dwData["WTBANZFAE90"].ToString();
            or1.Parameters.Add("WTBFNR91", OracleType.NVarChar).Value = dwData["WTBFNR91"].ToString();
            or1.Parameters.Add("WTBANZFAE91", OracleType.NVarChar).Value = dwData["WTBANZFAE91"].ToString();
            or1.Parameters.Add("WTBFNR92", OracleType.NVarChar).Value = dwData["WTBFNR92"].ToString();
            or1.Parameters.Add("WTBANZFAE92", OracleType.NVarChar).Value = dwData["WTBANZFAE92"].ToString();
            or1.Parameters.Add("WTBFNR93", OracleType.NVarChar).Value = dwData["WTBFNR93"].ToString();
            or1.Parameters.Add("WTBANZFAE93", OracleType.NVarChar).Value = dwData["WTBANZFAE93"].ToString();
            or1.Parameters.Add("WTBFNR94", OracleType.NVarChar).Value = dwData["WTBFNR94"].ToString();
            or1.Parameters.Add("WTBANZFAE94", OracleType.NVarChar).Value = dwData["WTBANZFAE94"].ToString();
            or1.Parameters.Add("WTBFNR95", OracleType.NVarChar).Value = dwData["WTBFNR95"].ToString();
            or1.Parameters.Add("WTBANZFAE95", OracleType.NVarChar).Value = dwData["WTBANZFAE95"].ToString();
            or1.Parameters.Add("WTBFNR96", OracleType.NVarChar).Value = dwData["WTBFNR96"].ToString();
            or1.Parameters.Add("WTBANZFAE96", OracleType.NVarChar).Value = dwData["WTBANZFAE96"].ToString();
            or1.Parameters.Add("WTBFNR97", OracleType.NVarChar).Value = dwData["WTBFNR97"].ToString();
            or1.Parameters.Add("WTBANZFAE97", OracleType.NVarChar).Value = dwData["WTBANZFAE97"].ToString();
            or1.Parameters.Add("WTBFNR98", OracleType.NVarChar).Value = dwData["WTBFNR98"].ToString();
            or1.Parameters.Add("WTBANZFAE98", OracleType.NVarChar).Value = dwData["WTBANZFAE98"].ToString();
            or1.Parameters.Add("WTBFNR99", OracleType.NVarChar).Value = dwData["WTBFNR99"].ToString();
            or1.Parameters.Add("WTBANZFAE99", OracleType.NVarChar).Value = dwData["WTBANZFAE99"].ToString();
            or1.Parameters.Add("WTBFNR4", OracleType.NVarChar).Value = dwData["WTBFNR4"].ToString();
            or1.Parameters.Add("WTBANZFAE4", OracleType.NVarChar).Value = dwData["WTBANZFAE4"].ToString();
            or1.Parameters.Add("WTBFNR5", OracleType.NVarChar).Value = dwData["WTBFNR5"].ToString();
            or1.Parameters.Add("WTBANZFAE5", OracleType.NVarChar).Value = dwData["WTBANZFAE5"].ToString();
            or1.Parameters.Add("WTBFNR6", OracleType.NVarChar).Value = dwData["WTBFNR6"].ToString();
            or1.Parameters.Add("WTBANZFAE6", OracleType.NVarChar).Value = dwData["WTBANZFAE6"].ToString();
            or1.Parameters.Add("WTBFNR7", OracleType.NVarChar).Value = dwData["WTBFNR7"].ToString();
            or1.Parameters.Add("WTBANZFAE7", OracleType.NVarChar).Value = dwData["WTBANZFAE7"].ToString();
            or1.Parameters.Add("WTBFNR8", OracleType.NVarChar).Value = dwData["WTBFNR8"].ToString();
            or1.Parameters.Add("WTBANZFAE8", OracleType.NVarChar).Value = dwData["WTBANZFAE8"].ToString();
            or1.Parameters.Add("WTBFNR9", OracleType.NVarChar).Value = dwData["WTBFNR9"].ToString();
            or1.Parameters.Add("WTBANZFAE9", OracleType.NVarChar).Value = dwData["WTBANZFAE9"].ToString();
            or1.Parameters.Add("WTBFNR10", OracleType.NVarChar).Value = dwData["WTBFNR10"].ToString();
            or1.Parameters.Add("WTBANZFAE10", OracleType.NVarChar).Value = dwData["WTBANZFAE10"].ToString();
            or1.Parameters.Add("WTBFNR11", OracleType.NVarChar).Value = dwData["WTBFNR11"].ToString();
            or1.Parameters.Add("WTBANZFAE11", OracleType.NVarChar).Value = dwData["WTBANZFAE11"].ToString();
            or1.Parameters.Add("WTBFNR12", OracleType.NVarChar).Value = dwData["WTBFNR12"].ToString();
            or1.Parameters.Add("WTBANZFAE12", OracleType.NVarChar).Value = dwData["WTBANZFAE12"].ToString();
            or1.Parameters.Add("WTBFNR13", OracleType.NVarChar).Value = dwData["WTBFNR13"].ToString();
            or1.Parameters.Add("WTBANZFAE13", OracleType.NVarChar).Value = dwData["WTBANZFAE13"].ToString();
            or1.Parameters.Add("WTBFNR14", OracleType.NVarChar).Value = dwData["WTBFNR14"].ToString();
            or1.Parameters.Add("WTBANZFAE14", OracleType.NVarChar).Value = dwData["WTBANZFAE14"].ToString();
            or1.Parameters.Add("WTBFNR15", OracleType.NVarChar).Value = dwData["WTBFNR15"].ToString();
            or1.Parameters.Add("WTBANZFAE15", OracleType.NVarChar).Value = dwData["WTBANZFAE15"].ToString();
            or1.Parameters.Add("WTBFNR16", OracleType.NVarChar).Value = dwData["WTBFNR16"].ToString();
            or1.Parameters.Add("WTBANZFAE16", OracleType.NVarChar).Value = dwData["WTBANZFAE16"].ToString();
            or1.Parameters.Add("WTBFNR17", OracleType.NVarChar).Value = dwData["WTBFNR17"].ToString();
            or1.Parameters.Add("WTBANZFAE17", OracleType.NVarChar).Value = dwData["WTBANZFAE17"].ToString();
            or1.Parameters.Add("WTBFNR18", OracleType.NVarChar).Value = dwData["WTBFNR18"].ToString();
            or1.Parameters.Add("WTBANZFAE18", OracleType.NVarChar).Value = dwData["WTBANZFAE18"].ToString();
            or1.Parameters.Add("WTBFNR19", OracleType.NVarChar).Value = dwData["WTBFNR19"].ToString();
            or1.Parameters.Add("WTBANZFAE19", OracleType.NVarChar).Value = dwData["WTBANZFAE19"].ToString();
            or1.Parameters.Add("WTBFNR20", OracleType.NVarChar).Value = dwData["WTBFNR20"].ToString();
            or1.Parameters.Add("WTBANZFAE20", OracleType.NVarChar).Value = dwData["WTBANZFAE20"].ToString();
            or1.Parameters.Add("WTBFNR21", OracleType.NVarChar).Value = dwData["WTBFNR21"].ToString();
            or1.Parameters.Add("WTBANZFAE21", OracleType.NVarChar).Value = dwData["WTBANZFAE21"].ToString();
            or1.Parameters.Add("WTBFNR22", OracleType.NVarChar).Value = dwData["WTBFNR22"].ToString();
            or1.Parameters.Add("WTBANZFAE22", OracleType.NVarChar).Value = dwData["WTBANZFAE22"].ToString();
            or1.Parameters.Add("WTBFDZ28", OracleType.NVarChar).Value = dwData["WTBFDZ28"].ToString();
            or1.Parameters.Add("WTBGARN29", OracleType.NVarChar).Value = dwData["WTBGARN29"].ToString();
            or1.Parameters.Add("WTBFDZ29", OracleType.NVarChar).Value = dwData["WTBFDZ29"].ToString();
            or1.Parameters.Add("WTBGARN30", OracleType.NVarChar).Value = dwData["WTBGARN30"].ToString();
            or1.Parameters.Add("WTBFDZ30", OracleType.NVarChar).Value = dwData["WTBFDZ30"].ToString();
            or1.Parameters.Add("WTBGARN31", OracleType.NVarChar).Value = dwData["WTBGARN31"].ToString();
            or1.Parameters.Add("WTBFDZ31", OracleType.NVarChar).Value = dwData["WTBFDZ31"].ToString();
            or1.Parameters.Add("WTBGARN32", OracleType.NVarChar).Value = dwData["WTBGARN32"].ToString();
            or1.Parameters.Add("WTBFDZ32", OracleType.NVarChar).Value = dwData["WTBFDZ32"].ToString();
            or1.Parameters.Add("WTBGARN33", OracleType.NVarChar).Value = dwData["WTBGARN33"].ToString();
            or1.Parameters.Add("WTBFDZ33", OracleType.NVarChar).Value = dwData["WTBFDZ33"].ToString();
            or1.Parameters.Add("WTBGARN34", OracleType.NVarChar).Value = dwData["WTBGARN34"].ToString();
            or1.Parameters.Add("WTBFDZ34", OracleType.NVarChar).Value = dwData["WTBFDZ34"].ToString();
            or1.Parameters.Add("WTBGARN35", OracleType.NVarChar).Value = dwData["WTBGARN35"].ToString();
            or1.Parameters.Add("WTBFDZ35", OracleType.NVarChar).Value = dwData["WTBFDZ35"].ToString();
            or1.Parameters.Add("WTBGARN36", OracleType.NVarChar).Value = dwData["WTBGARN36"].ToString();
            or1.Parameters.Add("WTBFDZ36", OracleType.NVarChar).Value = dwData["WTBFDZ36"].ToString();
            or1.Parameters.Add("WTBGARN37", OracleType.NVarChar).Value = dwData["WTBGARN37"].ToString();
            or1.Parameters.Add("WTBFDZ37", OracleType.NVarChar).Value = dwData["WTBFDZ37"].ToString();
            or1.Parameters.Add("WTBGARN38", OracleType.NVarChar).Value = dwData["WTBGARN38"].ToString();
            or1.Parameters.Add("WTBFDZ38", OracleType.NVarChar).Value = dwData["WTBFDZ38"].ToString();
            or1.Parameters.Add("WTBGARN39", OracleType.NVarChar).Value = dwData["WTBGARN39"].ToString();
            or1.Parameters.Add("WTBFDZ39", OracleType.NVarChar).Value = dwData["WTBFDZ39"].ToString();
            or1.Parameters.Add("WTBGARN40", OracleType.NVarChar).Value = dwData["WTBGARN40"].ToString();
            or1.Parameters.Add("WTBFDZ40", OracleType.NVarChar).Value = dwData["WTBFDZ40"].ToString();
            or1.Parameters.Add("WTBGARN41", OracleType.NVarChar).Value = dwData["WTBGARN41"].ToString();
            or1.Parameters.Add("WTBFDZ41", OracleType.NVarChar).Value = dwData["WTBFDZ41"].ToString();
            or1.Parameters.Add("WTBGARN42", OracleType.NVarChar).Value = dwData["WTBGARN42"].ToString();
            or1.Parameters.Add("WTBFDZ42", OracleType.NVarChar).Value = dwData["WTBFDZ42"].ToString();
            or1.Parameters.Add("WTBGARN43", OracleType.NVarChar).Value = dwData["WTBGARN43"].ToString();
            or1.Parameters.Add("WTBFDZ43", OracleType.NVarChar).Value = dwData["WTBFDZ43"].ToString();
            or1.Parameters.Add("WTBGARN44", OracleType.NVarChar).Value = dwData["WTBGARN44"].ToString();
            or1.Parameters.Add("WTBFDZ44", OracleType.NVarChar).Value = dwData["WTBFDZ44"].ToString();
            or1.Parameters.Add("WTBGARN45", OracleType.NVarChar).Value = dwData["WTBGARN45"].ToString();
            or1.Parameters.Add("WTBFDZ45", OracleType.NVarChar).Value = dwData["WTBFDZ45"].ToString();
            or1.Parameters.Add("WTBGARN46", OracleType.NVarChar).Value = dwData["WTBGARN46"].ToString();
            or1.Parameters.Add("WTBFDZ46", OracleType.NVarChar).Value = dwData["WTBFDZ46"].ToString();
            or1.Parameters.Add("WTBGARN47", OracleType.NVarChar).Value = dwData["WTBGARN47"].ToString();
            or1.Parameters.Add("WTBFDZ47", OracleType.NVarChar).Value = dwData["WTBFDZ47"].ToString();
            or1.Parameters.Add("WTBGARN48", OracleType.NVarChar).Value = dwData["WTBGARN48"].ToString();
            or1.Parameters.Add("WTBFDZ48", OracleType.NVarChar).Value = dwData["WTBFDZ48"].ToString();
            or1.Parameters.Add("WTBGARN49", OracleType.NVarChar).Value = dwData["WTBGARN49"].ToString();
            or1.Parameters.Add("WTBFDZ49", OracleType.NVarChar).Value = dwData["WTBFDZ49"].ToString();
            or1.Parameters.Add("WTBGARN50", OracleType.NVarChar).Value = dwData["WTBGARN50"].ToString();
            or1.Parameters.Add("WTBFDZ50", OracleType.NVarChar).Value = dwData["WTBFDZ50"].ToString();
            or1.Parameters.Add("WTBGARN51", OracleType.NVarChar).Value = dwData["WTBGARN51"].ToString();
            or1.Parameters.Add("WTBFDZ51", OracleType.NVarChar).Value = dwData["WTBFDZ51"].ToString();
            or1.Parameters.Add("WTBGARN52", OracleType.NVarChar).Value = dwData["WTBGARN52"].ToString();
            or1.Parameters.Add("WTBFDZ52", OracleType.NVarChar).Value = dwData["WTBFDZ52"].ToString();
            or1.Parameters.Add("WTBGARN53", OracleType.NVarChar).Value = dwData["WTBGARN53"].ToString();
            or1.Parameters.Add("WTBFDZ53", OracleType.NVarChar).Value = dwData["WTBFDZ53"].ToString();
            or1.Parameters.Add("WTBGARN54", OracleType.NVarChar).Value = dwData["WTBGARN54"].ToString();
            or1.Parameters.Add("WTBFDZ54", OracleType.NVarChar).Value = dwData["WTBFDZ54"].ToString();
            or1.Parameters.Add("WTBGARN55", OracleType.NVarChar).Value = dwData["WTBGARN55"].ToString();
            or1.Parameters.Add("WTBFDZ55", OracleType.NVarChar).Value = dwData["WTBFDZ55"].ToString();
            or1.Parameters.Add("WTBGARN56", OracleType.NVarChar).Value = dwData["WTBGARN56"].ToString();
            or1.Parameters.Add("WTBFDZ56", OracleType.NVarChar).Value = dwData["WTBFDZ56"].ToString();
            or1.Parameters.Add("WTBGARN57", OracleType.NVarChar).Value = dwData["WTBGARN57"].ToString();
            or1.Parameters.Add("WTBFDZ57", OracleType.NVarChar).Value = dwData["WTBFDZ57"].ToString();
            or1.Parameters.Add("WTBGARN58", OracleType.NVarChar).Value = dwData["WTBGARN58"].ToString();
            or1.Parameters.Add("WTBFDZ58", OracleType.NVarChar).Value = dwData["WTBFDZ58"].ToString();
            or1.Parameters.Add("WTBGARN59", OracleType.NVarChar).Value = dwData["WTBGARN59"].ToString();
            or1.Parameters.Add("WTBFDZ59", OracleType.NVarChar).Value = dwData["WTBFDZ59"].ToString();
            or1.Parameters.Add("WTBGARN60", OracleType.NVarChar).Value = dwData["WTBGARN60"].ToString();
            or1.Parameters.Add("WTBFDZ60", OracleType.NVarChar).Value = dwData["WTBFDZ60"].ToString();
            or1.Parameters.Add("WTBGARN61", OracleType.NVarChar).Value = dwData["WTBGARN61"].ToString();
            or1.Parameters.Add("WTBFDZ61", OracleType.NVarChar).Value = dwData["WTBFDZ61"].ToString();
            or1.Parameters.Add("WTBGARN62", OracleType.NVarChar).Value = dwData["WTBGARN62"].ToString();
            or1.Parameters.Add("WTBFDZ62", OracleType.NVarChar).Value = dwData["WTBFDZ62"].ToString();
            or1.Parameters.Add("WTBGARN63", OracleType.NVarChar).Value = dwData["WTBGARN63"].ToString();
            or1.Parameters.Add("WTBFDZ63", OracleType.NVarChar).Value = dwData["WTBFDZ63"].ToString();
            or1.Parameters.Add("WTBGARN64", OracleType.NVarChar).Value = dwData["WTBGARN64"].ToString();
            or1.Parameters.Add("WTBFDZ64", OracleType.NVarChar).Value = dwData["WTBFDZ64"].ToString();
            or1.Parameters.Add("WTBGARN65", OracleType.NVarChar).Value = dwData["WTBGARN65"].ToString();
            or1.Parameters.Add("WTBFDZ65", OracleType.NVarChar).Value = dwData["WTBFDZ65"].ToString();
            or1.Parameters.Add("WTBGARN66", OracleType.NVarChar).Value = dwData["WTBGARN66"].ToString();
            or1.Parameters.Add("WTBFDZ66", OracleType.NVarChar).Value = dwData["WTBFDZ66"].ToString();
            or1.Parameters.Add("WTBGARN67", OracleType.NVarChar).Value = dwData["WTBGARN67"].ToString();
            or1.Parameters.Add("WTBFDZ67", OracleType.NVarChar).Value = dwData["WTBFDZ67"].ToString();
            or1.Parameters.Add("WTBGARN68", OracleType.NVarChar).Value = dwData["WTBGARN68"].ToString();
            or1.Parameters.Add("WTBFDZ68", OracleType.NVarChar).Value = dwData["WTBFDZ68"].ToString();
            or1.Parameters.Add("WTBGARN69", OracleType.NVarChar).Value = dwData["WTBGARN69"].ToString();
            or1.Parameters.Add("WTBFDZ69", OracleType.NVarChar).Value = dwData["WTBFDZ69"].ToString();
            or1.Parameters.Add("WTBGARN70", OracleType.NVarChar).Value = dwData["WTBGARN70"].ToString();
            or1.Parameters.Add("WTBFDZ70", OracleType.NVarChar).Value = dwData["WTBFDZ70"].ToString();
            or1.Parameters.Add("WTBGARN71", OracleType.NVarChar).Value = dwData["WTBGARN71"].ToString();
            or1.Parameters.Add("WTBFDZ71", OracleType.NVarChar).Value = dwData["WTBFDZ71"].ToString();
            or1.Parameters.Add("WTBGARN72", OracleType.NVarChar).Value = dwData["WTBGARN72"].ToString();
            or1.Parameters.Add("WTBFDZ72", OracleType.NVarChar).Value = dwData["WTBFDZ72"].ToString();
            or1.Parameters.Add("WTBGARN73", OracleType.NVarChar).Value = dwData["WTBGARN73"].ToString();
            or1.Parameters.Add("WTBFDZ73", OracleType.NVarChar).Value = dwData["WTBFDZ73"].ToString();
            or1.Parameters.Add("WTBGARN74", OracleType.NVarChar).Value = dwData["WTBGARN74"].ToString();
            or1.Parameters.Add("WTBFDZ74", OracleType.NVarChar).Value = dwData["WTBFDZ74"].ToString();
            or1.Parameters.Add("WTBGARN75", OracleType.NVarChar).Value = dwData["WTBGARN75"].ToString();
            or1.Parameters.Add("WTBFDZ75", OracleType.NVarChar).Value = dwData["WTBFDZ75"].ToString();
            or1.Parameters.Add("WTBGARN76", OracleType.NVarChar).Value = dwData["WTBGARN76"].ToString();
            or1.Parameters.Add("WTBFDZ76", OracleType.NVarChar).Value = dwData["WTBFDZ76"].ToString();
            or1.Parameters.Add("WTBGARN77", OracleType.NVarChar).Value = dwData["WTBGARN77"].ToString();
            or1.Parameters.Add("WTBFDZ77", OracleType.NVarChar).Value = dwData["WTBFDZ77"].ToString();
            or1.Parameters.Add("WTBGARN78", OracleType.NVarChar).Value = dwData["WTBGARN78"].ToString();
            or1.Parameters.Add("WTBFDZ78", OracleType.NVarChar).Value = dwData["WTBFDZ78"].ToString();
            or1.Parameters.Add("WTBGARN79", OracleType.NVarChar).Value = dwData["WTBGARN79"].ToString();
            or1.Parameters.Add("WTBFDZ79", OracleType.NVarChar).Value = dwData["WTBFDZ79"].ToString();
            or1.Parameters.Add("WTBGARN80", OracleType.NVarChar).Value = dwData["WTBGARN80"].ToString();
            or1.Parameters.Add("WTBFDZ80", OracleType.NVarChar).Value = dwData["WTBFDZ80"].ToString();
            or1.Parameters.Add("WTBFNR1", OracleType.NVarChar).Value = dwData["WTBFNR1"].ToString();
            or1.Parameters.Add("WTBANZFAE1", OracleType.NVarChar).Value = dwData["WTBANZFAE1"].ToString();
            or1.Parameters.Add("WTBFNR2", OracleType.NVarChar).Value = dwData["WTBFNR2"].ToString();
            or1.Parameters.Add("WTBANZFAE2", OracleType.NVarChar).Value = dwData["WTBANZFAE2"].ToString();
            or1.Parameters.Add("WTBFNR3", OracleType.NVarChar).Value = dwData["WTBFNR3"].ToString();
            or1.Parameters.Add("WTBANZFAE3", OracleType.NVarChar).Value = dwData["WTBANZFAE3"].ToString();
            or1.Parameters.Add("WTBFNR61", OracleType.NVarChar).Value = dwData["WTBFNR61"].ToString();
            or1.Parameters.Add("WTBANZFAE61", OracleType.NVarChar).Value = dwData["WTBANZFAE61"].ToString();
            or1.Parameters.Add("WTBFNR62", OracleType.NVarChar).Value = dwData["WTBFNR62"].ToString();
            or1.Parameters.Add("WTBANZFAE62", OracleType.NVarChar).Value = dwData["WTBANZFAE62"].ToString();
            or1.Parameters.Add("WTBFNR63", OracleType.NVarChar).Value = dwData["WTBFNR63"].ToString();
            or1.Parameters.Add("WTBANZFAE63", OracleType.NVarChar).Value = dwData["WTBANZFAE63"].ToString();
            or1.Parameters.Add("WTBFNR64", OracleType.NVarChar).Value = dwData["WTBFNR64"].ToString();
            or1.Parameters.Add("WTBANZFAE64", OracleType.NVarChar).Value = dwData["WTBANZFAE64"].ToString();
            or1.Parameters.Add("WTBFNR65", OracleType.NVarChar).Value = dwData["WTBFNR65"].ToString();
            or1.Parameters.Add("WTBANZFAE65", OracleType.NVarChar).Value = dwData["WTBANZFAE65"].ToString();
            or1.Parameters.Add("WTBFNR66", OracleType.NVarChar).Value = dwData["WTBFNR66"].ToString();
            or1.Parameters.Add("WTBANZFAE66", OracleType.NVarChar).Value = dwData["WTBANZFAE66"].ToString();
            or1.Parameters.Add("WTBFNR67", OracleType.NVarChar).Value = dwData["WTBFNR67"].ToString();
            or1.Parameters.Add("WTBANZFAE67", OracleType.NVarChar).Value = dwData["WTBANZFAE67"].ToString();
            or1.Parameters.Add("WTBFNR68", OracleType.NVarChar).Value = dwData["WTBFNR68"].ToString();
            or1.Parameters.Add("WTBANZFAE68", OracleType.NVarChar).Value = dwData["WTBANZFAE68"].ToString();
            or1.Parameters.Add("WTBFNR69", OracleType.NVarChar).Value = dwData["WTBFNR69"].ToString();
            or1.Parameters.Add("WTBANZFAE69", OracleType.NVarChar).Value = dwData["WTBANZFAE69"].ToString();
            or1.Parameters.Add("WTBFNR70", OracleType.NVarChar).Value = dwData["WTBFNR70"].ToString();
            or1.Parameters.Add("WTBANZFAE70", OracleType.NVarChar).Value = dwData["WTBANZFAE70"].ToString();
            or1.Parameters.Add("WTBFNR71", OracleType.NVarChar).Value = dwData["WTBFNR71"].ToString();
            or1.Parameters.Add("WTBANZFAE71", OracleType.NVarChar).Value = dwData["WTBANZFAE71"].ToString();
            or1.Parameters.Add("WTBFNR72", OracleType.NVarChar).Value = dwData["WTBFNR72"].ToString();
            or1.Parameters.Add("WTBANZFAE72", OracleType.NVarChar).Value = dwData["WTBANZFAE72"].ToString();
            or1.Parameters.Add("WTBFNR73", OracleType.NVarChar).Value = dwData["WTBFNR73"].ToString();
            or1.Parameters.Add("WTBANZFAE73", OracleType.NVarChar).Value = dwData["WTBANZFAE73"].ToString();
            or1.Parameters.Add("WTBFNR74", OracleType.NVarChar).Value = dwData["WTBFNR74"].ToString();
            or1.Parameters.Add("WTBANZFAE74", OracleType.NVarChar).Value = dwData["WTBANZFAE74"].ToString();
            or1.Parameters.Add("WTBFNR75", OracleType.NVarChar).Value = dwData["WTBFNR75"].ToString();
            or1.Parameters.Add("WTBANZFAE75", OracleType.NVarChar).Value = dwData["WTBANZFAE75"].ToString();
            or1.Parameters.Add("WTBFNR76", OracleType.NVarChar).Value = dwData["WTBFNR76"].ToString();
            or1.Parameters.Add("WTBANZFAE76", OracleType.NVarChar).Value = dwData["WTBANZFAE76"].ToString();
            or1.Parameters.Add("WTBFNR77", OracleType.NVarChar).Value = dwData["WTBFNR77"].ToString();
            or1.Parameters.Add("WTBANZFAE77", OracleType.NVarChar).Value = dwData["WTBANZFAE77"].ToString();
            or1.Parameters.Add("WTBFNR78", OracleType.NVarChar).Value = dwData["WTBFNR78"].ToString();
            or1.Parameters.Add("WTBANZFAE78", OracleType.NVarChar).Value = dwData["WTBANZFAE78"].ToString();
            or1.Parameters.Add("WTBFNR79", OracleType.NVarChar).Value = dwData["WTBFNR79"].ToString();
            or1.Parameters.Add("WTBANZFAE79", OracleType.NVarChar).Value = dwData["WTBANZFAE79"].ToString();
            or1.Parameters.Add("WTBFNR80", OracleType.NVarChar).Value = dwData["WTBFNR80"].ToString();
            #endregion
            Connect2Proxy(or1);
        }
    }
}
